package com.sansan.qiangji.mapper.warehouse;

import com.sansan.qiangji.VO.board.CountPullBoxVO;
import com.sansan.qiangji.entity.warehouse.PullOrderBoxDetail;
import com.sansan.qiangji.entity.warehouse.example.PullOrderBoxDetailExample;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface PullOrderBoxDetailMapper {
    List<PullOrderBoxDetail> findByBoxDetailCode(@Param("boxDetailCode") String boxDetailCode);

    List<PullOrderBoxDetail> findByDetailCodeAndStatus(@Param("pullOrderDetailCode") String pullOrderDetailCode, @Param("boxDetailStatus") String boxDetailStatus);
    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table pull_order_box_detail
     *
     * @mbg.generated Sat Nov 07 14:07:06 CST 2020
     */
    long countByExample(PullOrderBoxDetailExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table pull_order_box_detail
     *
     * @mbg.generated Sat Nov 07 14:07:06 CST 2020
     */
    int deleteByExample(PullOrderBoxDetailExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table pull_order_box_detail
     *
     * @mbg.generated Sat Nov 07 14:07:06 CST 2020
     */
    int deleteByPrimaryKey(Integer boxDetailId);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table pull_order_box_detail
     *
     * @mbg.generated Sat Nov 07 14:07:06 CST 2020
     */
    int insert(PullOrderBoxDetail record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table pull_order_box_detail
     *
     * @mbg.generated Sat Nov 07 14:07:06 CST 2020
     */
    int insertSelective(PullOrderBoxDetail record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table pull_order_box_detail
     *
     * @mbg.generated Sat Nov 07 14:07:06 CST 2020
     */
    List<PullOrderBoxDetail> selectByExample(PullOrderBoxDetailExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table pull_order_box_detail
     *
     * @mbg.generated Sat Nov 07 14:07:06 CST 2020
     */
    PullOrderBoxDetail selectByPrimaryKey(Integer boxDetailId);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table pull_order_box_detail
     *
     * @mbg.generated Sat Nov 07 14:07:06 CST 2020
     */
    int updateByExampleSelective(@Param("record") PullOrderBoxDetail record, @Param("example") PullOrderBoxDetailExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table pull_order_box_detail
     *
     * @mbg.generated Sat Nov 07 14:07:06 CST 2020
     */
    int updateByExample(@Param("record") PullOrderBoxDetail record, @Param("example") PullOrderBoxDetailExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table pull_order_box_detail
     *
     * @mbg.generated Sat Nov 07 14:07:06 CST 2020
     */
    int updateByPrimaryKeySelective(PullOrderBoxDetail record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table pull_order_box_detail
     *
     * @mbg.generated Sat Nov 07 14:07:06 CST 2020
     */
    int updateByPrimaryKey(PullOrderBoxDetail record);

    List<CountPullBoxVO> countPullBox();
}
